package com.personnalManagerSystem.mapper;

import com.personnalManagerSystem.model.Wage;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Update;
import org.springframework.web.bind.annotation.RequestParam;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author liqing
 * @since 2022-03-27
 */
public interface WageMapper extends BaseMapper<Wage> {
    @Update("update wage set  total_salary= basic_pay+commission-deduct_money where wage_id =#{wageId}")
    Boolean getTotalSalary(@RequestParam("wageId") Integer id);
}
